package com.hifar.test.exporttask.controller;

import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.hifar.plat.baseModal.service.IBaseOssFilesService;
import com.hifar.plat.officUtil.ExcelTemplateUtil;
import com.hifar.test.exporttask.pojo.SysSyncExportTask;
import com.hifar.test.exporttask.service.ISysSyncExportTaskService;
import com.hifar.sys.*;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpHeaders;
import org.springframework.http.HttpStatus;
import org.springframework.http.ResponseEntity;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import javax.servlet.http.HttpServletRequest;
import java.io.UnsupportedEncodingException;
import java.net.URLEncoder;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 双网同步-导出-任务表 前端控制器 default
 * </p>
 *
 * @author wangkepeng
 * @since 2024-12-26 14:17:47
 */
@RestController
@RequestMapping("/api/busi/proj/sysSyncExportTaskController")
@Api(tags = "双网同步-导出-任务表功能")
public class SysSyncExportTaskController {

    @Autowired
    private ISysSyncExportTaskService sysSyncExportTaskService;

    @Autowired
    private IBaseOssFilesService baseOssFilesService;
    
    

    @PostMapping(value = "/list")
    @ApiOperation(value = "双网同步-导出-任务表功能:分页查询列表")
    public BusiResponse list(HttpServletRequest request) {
        Map<String,Object> pageInfo = RequestConver.getPageInfo(request);
        QueryWrapper<SysSyncExportTask> queryWrapper = RequestConver.getPostParam(pageInfo);
        queryWrapper.ne("del_flag", "1");
        queryWrapper.orderByDesc("create_time");
        queryWrapper.in("secret_level",SystemLoginUser.dataSecretSet);
        if (queryWrapper != null && pageInfo.size() > 0) {
             Page<SysSyncExportTask> page = new Page<>((Integer) pageInfo.get("pageNo"), (Integer)pageInfo.get("pageSize"));
             Page<SysSyncExportTask> page1 = sysSyncExportTaskService.page(page, queryWrapper);
             page1.getRecords().forEach(item->{
             });
             /*计算分页信息返回给前端*/
             PageResult pageResult = SystemUtil.parsePage(page, page1);
             return BusiResponse.OK(pageResult);
        }else {
             return BusiResponse.error("参数不正确！");
        }
    }

    @PostMapping(value = "/listAll")
    @ApiOperation(value = "双网同步-导出-任务表功能:查询列表(不带分页)")
    public BusiResponse listAll(HttpServletRequest request) {
        QueryWrapper<SysSyncExportTask> queryWrapper = new QueryWrapper<>();
        queryWrapper.orderByDesc("create_time");
        queryWrapper.ne("del_flag", "1");
        queryWrapper.in("secret_level",SystemLoginUser.dataSecretSet);
        List<SysSyncExportTask> list = sysSyncExportTaskService.list(queryWrapper);
        list.forEach(item->{
        });
        if (list != null && list.size() > 0) {
            return BusiResponse.OK(list);
        }else {
            return BusiResponse.ok("没有查询到数据！");
        }
    }

    @PostMapping(value = "/add")
    @ApiOperation(value = "双网同步-导出-任务表功能:新增")
    public BusiResponse add(@RequestBody SysSyncExportTask sysSyncExportTask) {
        sysSyncExportTaskService.save(sysSyncExportTask);
        return BusiResponse.ok("添加成功");
    }





    @PostMapping(value = "/edit")
    @ApiOperation(value = "双网同步-导出-任务表功能:编辑")
    public BusiResponse edit(@RequestBody SysSyncExportTask sysSyncExportTask) {
        sysSyncExportTaskService.updateById(sysSyncExportTask);
        return BusiResponse.ok("编辑成功！");
    }




    @GetMapping("/queryById")
    @ApiOperation(value = "双网同步-导出-任务表功能:根据id查询数据")
    public BusiResponse queryById(@RequestParam(name = "id") String id){
        SysSyncExportTask byId = sysSyncExportTaskService.getById(id);
        // 查询转换附件
        return BusiResponse.OK(byId);
    }




    @PostMapping("/delete")
    @ApiOperation(value = "双网同步-导出-任务表功能:逻辑删除")
    public BusiResponse delete(@RequestBody List<String> idList){
        QueryWrapper<SysSyncExportTask> delete = new QueryWrapper<>();
        delete.in("id",idList);
        sysSyncExportTaskService.remove(delete);
        return BusiResponse.ok("删除成功！");
    }
   
    @PostMapping("/exportExcel")
	@ApiOperation(value = "双网同步-导出-任务表功能:导出数据")
	public Object exportExcel(HttpServletRequest request) {
		Map<String, Object> pageInfo = RequestConver.getPageInfo(request);
		if (pageInfo == null) {
			return BusiResponse.error("参数有误！");
		}
		BusiResponse export = sysSyncExportTaskService.exportExcel(pageInfo);
		if (export.getCode() == com.hifar.fw.utils.bean.BusiConst.CODE_SUCCESS) {
			String encode = null;
			try {
				encode = URLEncoder.encode("双网同步-导出-任务表.xlsx", "UTF-8");
			} catch (UnsupportedEncodingException e) {
				e.printStackTrace();
			}
			HttpHeaders headers = new HttpHeaders();
			headers.add("Content-Type", "application/vnd.ms-excel");
			headers.add("Access-Control-Expose-Headers", "Content-Disposition");
			headers.add("Content-Disposition", "filename=" + encode);
			return ResponseEntity.status(HttpStatus.OK).headers(headers).body((byte[]) export.getData());
		}
		return export;
	}

	@PostMapping("/importExcel")
	@ApiOperation(value = "双网同步-导出-任务表功能:导入excel数据")
	public BusiResponse importExcel(@RequestParam("file") MultipartFile file) throws Exception {
		if (file.isEmpty()) {
			return BusiResponse.error("文件为空！");
		} else {
			if (ExcelTemplateUtil.isExcelFile(file)) {
				return sysSyncExportTaskService.importExcel(file);
			} else {
				return BusiResponse.error("请上传excel文件！");
			}
		}
	}
    

}